package com.ruoyi.web.controller.system;

import java.io.*;
import java.util.List;

import com.alibaba.fastjson2.JSON;
import com.alibaba.fastjson2.JSONArray;
import com.alibaba.fastjson2.JSONObject;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.utils.DictUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import org.apache.commons.lang3.ArrayUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.constant.UserConstants;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.SysDept;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.system.service.ISysDeptService;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;

import static io.lettuce.core.pubsub.PubSubOutput.Type.message;

/**
 * 部门信息
 * 
 * @author ruoyi
 */
@RestController
@RequestMapping("/system/dept")
public class SysDeptController extends BaseController
{
    @Autowired
    private ISysDeptService deptService;

    /**
     * 获取部门列表
     */
    @PreAuthorize("@ss.hasPermi('system:dept:list')")
    @GetMapping("/list")
    public AjaxResult list(SysDept dept)
    {
        List<SysDept> depts = deptService.selectDeptList(dept);
        return success(depts);
    }

    /**
     * 导出项目列表
     */
    @PreAuthorize("@ss.hasPermi('system:dept:list')")
    @PostMapping("/list")
    public void listExport(HttpServletResponse response, SysDept dept)
    {
        List<SysDept> depts = deptService.selectDeptList(dept);
        ExcelUtil<SysDept> util = new ExcelUtil<SysDept>(SysDept.class);
        util.exportExcel(response, depts, "项目列表");
    }

    /**
     * 导入项目数据
     */
    @PostMapping("/importData")
    public AjaxResult importData(MultipartFile file) throws Exception
    {
        ExcelUtil<SysDept> util = new ExcelUtil<SysDept>(SysDept.class);
        List<SysDept> deptList = util.importExcel(file.getInputStream());
        return toAjax(deptService.batchInsertDept(deptList));
    }

    /**
     * 导出模板
    */
    @PostMapping("/importTemplate")
    public void importTemplate(HttpServletResponse response)
    {
        ExcelUtil<SysDept> util = new ExcelUtil<SysDept>(SysDept.class);
        util.importTemplateExcel(response, "项目管理");
    }

    /**
     * 查询项目视图
     */
    @PreAuthorize("@ss.hasPermi('system:task:query')")
    @GetMapping(value = "/view")
    public AjaxResult getView()
    {
        return success(deptService.getView());
    }

    /**
     * 查询部门列表（排除节点）
     */
    @PreAuthorize("@ss.hasPermi('system:dept:list')")
    @GetMapping("/list/exclude/{deptId}")
    public AjaxResult excludeChild(@PathVariable(value = "deptId", required = false) Long deptId)
    {
        List<SysDept> depts = deptService.selectDeptList(new SysDept());
        depts.removeIf(d -> d.getDeptId().intValue() == deptId || ArrayUtils.contains(StringUtils.split(d.getAncestors(), ","), deptId + ""));
        return success(depts);
    }

    /**
     * 根据部门编号获取详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:dept:query')")
    @GetMapping(value = "/{deptId}")
    public AjaxResult getInfo(@PathVariable Long deptId)
    {
        deptService.checkDeptDataScope(deptId);
        return success(deptService.selectDeptById(deptId));
    }

    /**
     * 新增部门
     */
    @PreAuthorize("@ss.hasPermi('system:dept:add')")
    @Log(title = "部门管理", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@Validated @RequestBody SysDept dept)
    {
        if (!deptService.checkDeptNameUnique(dept))
        {
            return error("新增部门'" + dept.getDeptName() + "'失败，部门名称已存在");
        }
        dept.setCreateBy(getUsername());
        return toAjax(deptService.insertDept(dept));
    }

    /**
     * 修改部门
     */
    @PreAuthorize("@ss.hasPermi('system:dept:edit')")
    @Log(title = "部门管理", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@Validated @RequestBody SysDept dept)
    {
        Long deptId = dept.getDeptId();
        deptService.checkDeptDataScope(deptId);
        if (!deptService.checkDeptNameUnique(dept))
        {
            return error("修改部门'" + dept.getDeptName() + "'失败，部门名称已存在");
        }
        else if (dept.getParentId().equals(deptId))
        {
            return error("修改部门'" + dept.getDeptName() + "'失败，上级部门不能是自己");
        }
        else if (StringUtils.equals(UserConstants.DEPT_DISABLE, dept.getStatus()) && deptService.selectNormalChildrenDeptById(deptId) > 0)
        {
            return error("该部门包含未停用的子部门！");
        }
        dept.setUpdateBy(getUsername());
        return toAjax(deptService.updateDept(dept));
    }

    /**
     * 删除部门
     */
    @PreAuthorize("@ss.hasPermi('system:dept:remove')")
    @Log(title = "部门管理", businessType = BusinessType.DELETE)
    @DeleteMapping("/{deptId}")
    public AjaxResult remove(@PathVariable Long deptId)
    {
        if (deptService.hasChildByDeptId(deptId))
        {
            return warn("存在下级部门,不允许删除");
        }
        if (deptService.checkDeptExistUser(deptId))
        {
            return warn("部门存在用户,不允许删除");
        }
        deptService.checkDeptDataScope(deptId);
        return toAjax(deptService.deleteDeptById(deptId));
    }

    /**
     * 查询所有项目负责人
     */
    @GetMapping("/getLeader")
    public AjaxResult getLeader()
    {
        List<SysUser> sysUsers = deptService.selectUserList();
        return success(sysUsers);
    }

    /**
     * 导出Excel
     */

    /**
     * Excel/Json导入项目
     */
    @PostMapping("/importDept")
    public AjaxResult importDept(MultipartFile file){
        //判断文件后缀
        String originalFilename = file.getOriginalFilename();
        assert originalFilename != null;
        originalFilename = originalFilename.substring(originalFilename.lastIndexOf(".") + 1);
        List<SysDept> list = null;

        if(!originalFilename.equals("xlsx")){
            //excel导入
            ExcelUtil excelUtil = new ExcelUtil(SysDept.class);
            try {
                list = excelUtil.importExcel(file.getInputStream());
            } catch (IOException e) {
                throw new RuntimeException("Excel文件导入失败",e);
            }
        }else {
            //json导入
            InputStream fileInputStream = null;
            try {
                fileInputStream = file.getInputStream();
            } catch (IOException e) {
                throw new RuntimeException(e);
            }
            //读取文件内容
            try{
                BufferedReader br = new BufferedReader(new InputStreamReader(fileInputStream));
                StringBuffer sb = new StringBuffer();
                char[] buffer = new char[8192]; // 8KB字符缓冲区
                int charsRead;
                while ((charsRead = br.read(buffer)) != -1) {
                    sb.append(buffer, 0, charsRead);
                }
                //解析JSON数据
                JSONArray jsonArray = JSON.parseArray(sb.toString());
                for (int i = 0; i < jsonArray.size(); i++) {
                    JSONObject jsonObject = jsonArray.getJSONObject(i);
                    SysDept sysDept = new SysDept();
                    sysDept.setDeptName(jsonObject.getString("deptName"));
                    sysDept.setParentId(jsonObject.getLong("parentId"));
                    sysDept.setLeader(jsonObject.getString("leader"));
                    sysDept.setPhone(jsonObject.getString("phone"));
                    sysDept.setEmail(jsonObject.getString("email"));
                    sysDept.setStatus(jsonObject.getString("status"));
                    sysDept.setOrderNum(jsonObject.getInteger("orderNum"));
                    sysDept.setDelFlag(jsonObject.getString("delFlag"));
                    sysDept.setStartTime(jsonObject.getDate("startTime"));
                    sysDept.setEndTime(jsonObject.getDate("endTime"));
                    sysDept.setRemark(jsonObject.getString("remark"));
                    list.add(sysDept);
                }
            } catch (IOException e) {
                e.printStackTrace();
            }

        }

        return toAjax(deptService.batchInsertDept(list));
    }

    /**
     * 填充字典值
     */
    public void fillDeptDict(SysDept... dept)
    {
        for (SysDept d : dept)
        {
            d.setStatus(DictUtils.getDictLabel("project_status", d.getStatus()));
        }
    }
}
